package com.financing.platform.dao;

import java.sql.SQLException;
import java.util.List;

import com.financing.platform.dto.ActivitiesGroupDTO;

public interface IActivitieGroupDao extends IBaseDao {
	
	/**
	 * 查询活动团信息
	 * @param agd
	 * @return
	 * @throws Exception
	 */
	public List<ActivitiesGroupDTO> queryActivitiesGroupInfo(ActivitiesGroupDTO agd) throws Exception;

	/**
	 * 查询活动团信息
	 * @param agd
	 * @return
	 * @throws Exception
	 */
	public int queryActivitiesGroupInfoCount(ActivitiesGroupDTO agd) throws Exception;




	/**
	 * 更新团队信息
	 * @param agd
	 * @return
	 * @throws Exception
	 */
	public int updateActivitiesGroup(ActivitiesGroupDTO agd) throws Exception;
	
	/**
	 * 根据用户手机号查询用户ID
	 * @param moblie
	 * @return
	 * @throws SQLException 
	 */
	public String queryFaIdByMoblie(String moblie) throws SQLException;
	
	/**
	 * 查询组时候已经领完红包
	 * @param agd
	 * @return
	 * @throws Exception
	 */
	public Integer queryFaHadGetGroupGift(ActivitiesGroupDTO agd) throws Exception;
	
	/**
	 * 统计当前团认证通过人数
	 * @param groupId
	 * @return
	 * @throws Exception
	 */
	public Integer queryActivitiesGroupAuthMember(ActivitiesGroupDTO agd) throws Exception;
	
	/**
	 * 查询认证通过人的信息
	 * @param groupId
	 * @return
	 * @throws Exception
	 */
	public List<ActivitiesGroupDTO> queryactGroupList(String groupId) throws Exception;
}
